TNS Connection General Settings

Connection Name
A friendly name to best describe your connection.

Type
Connection type for connecting to the server: Basic or TNS.

TNS
In TNS mode, Navicat connects to Oracle server using an alias entry from a tnsnames.ora file through the Oracle Call Interface (OCI). OCI is an application programming interface that allows an application developer to use a third-generation language's native procedure or function calls to access the Oracle database server and control all phases of SQL statement execution. OCI is a library of standard database access and retrieval functions in the form of a dynamic-link library.

Net Service Name
The net service name.

Role
Indicate that the database user is connecting with either the Default, SYSOPER or SYSDBA system privilege.

OS authentication
With this option on, Oracle Database uses OS user login credentials to authenticate database users.

User Name
User name for connecting to the database server.

Password
Password for connecting to the server.

See also:
Advanced Settings

Related topics:
Basic, SSH